from applications.extensions import db


class JyxtLand(db.Model):
    """
    交易系统成交宗地信息表
    """
    __tablename__ = 'jyxt_land'
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)  # 设置主键, 默认自增
    ZYID = db.Column(db.String(256))
    JDDW = db.Column(db.String(256))
    XZQMC = db.Column(db.String(256))
    ZYBH = db.Column(db.String(256))
    ZYWZ = db.Column(db.String(256))
    sfts = db.Column(db.String(2), default=0)